/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package Database;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author owner
 */
public class Create_Login {

    public static void main(String[] args) throws SQLException, FileNotFoundException, IOException {
        Connection con;
        con = Koneksi.open();
        Statement stat = con.createStatement();

        String buat = "create table LOGIN_T (NAMA varchar2(30),"
                + "PASSWORD varchar2(30))";
        stat.executeQuery(buat);
        String in = "insert into LOGIN_T(NAMA, PASSWORD)"
                + "values ('JGJ','jgj')";
        stat.executeUpdate(in);
        String in1 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('JKT','jkt')";
        stat.executeUpdate(in1);
        String in2 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('SMG','smg')";
        stat.executeUpdate(in2);
        String in3 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('SBY','sby')";
        stat.executeUpdate(in3);
        String in4 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('BDG','bdg')";
        stat.executeUpdate(in4);
        String in5= "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('LPG','lpg')";
        stat.executeUpdate(in5);
        String in6 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('MDN','mdn')";
        stat.executeUpdate(in6);
        String in7= "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('PLB','plb')";
        stat.executeUpdate(in7);
        String in8 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('DPS','dps')";
        stat.executeUpdate(in8);
        String in9 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('LBK','lbk')";
        stat.executeUpdate(in9);
        String in10 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('JYP','jyp')";
        stat.executeUpdate(in10);
        String in11 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('MKS','mks')";
        stat.executeUpdate(in11);
        String in12 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('MAN','man')";
        stat.executeUpdate(in12);
        String in13 = "insert into LOGIN_T(NAMA,PASSWORD)"
                + "values ('Admin','admin')";
        stat.executeUpdate(in13);
        System.out.println("table terisi");
    }
}
